home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
routes.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
884b
|
22 lines
/* RCSVER $Id: routes.sql,v 1.6 2000-03-15 14:16:38-06 randy Exp $ */
/* *************************************************************************
* Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
*
* Name: routes.sql
* Date: 12/28/1998
* memo: Randy Wood
* Description: Create the routes table. This table contains all routes
* defined in the system.
* Changes:
************************************************************************* */
CREATE TABLE routes
(
id NUMBER(38), /* ID of route */
descr VARCHAR2(30), /* Description of route */
wayid NUMBER(38), /* Route ID for wayfarer */
config_num NUMBER(38), /* Configuration number */
autogen NUMBER(1), /* Was this route auto-generated from trapeze? 1=YES 0=NO */
/* If NO, trapeze importing will not overwrite it */
CONSTRAINT pk_routes PRIMARY KEY (id, config_num)
);